/*
 Navicat Premium Data Transfer

 Source Server         : 本地brew安装mysql
 Source Server Type    : MySQL
 Source Server Version : 100214
 Source Host           : localhost:3306
 Source Schema         : project

 Target Server Type    : MySQL
 Target Server Version : 100214
 File Encoding         : 65001

 Date: 13/05/2018 02:49:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity
-- ----------------------------
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL DEFAULT 1,
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '活动名称',
  `pic` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片',
  `desc` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
  `start` date NOT NULL DEFAULT '0000-00-00' COMMENT '开始租赁时间',
  `end` date NOT NULL DEFAULT '0000-00-00' COMMENT '结束时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of activity
-- ----------------------------
BEGIN;
INSERT INTO `activity` VALUES (1, 1, 'activity1', '', 'the activity is nice', '2018-05-28', '2018-05-30');
INSERT INTO `activity` VALUES (2, 4, 'activity55', '', 'description description', '2018-05-03', '2018-05-04');
COMMIT;

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 1,
  `oid` int(11) NOT NULL DEFAULT 1,
  `type` varchar(40) NOT NULL DEFAULT '',
  `start` date NOT NULL DEFAULT '0000-00-00' COMMENT '开始时间',
  `end` date NOT NULL DEFAULT '0000-00-00' COMMENT '结束时间',
  `num` int(11) NOT NULL DEFAULT 1 COMMENT '数量',
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cart
-- ----------------------------
BEGIN;
INSERT INTO `cart` VALUES (5, 1, 1, 'hotel', '2018-05-02', '2018-05-04', 11, 1);
INSERT INTO `cart` VALUES (6, 1, 1, 'catering', '0000-00-00', '0000-00-00', 0, 1);
INSERT INTO `cart` VALUES (7, 1, 1, 'activity', '0000-00-00', '0000-00-00', 0, 1);
INSERT INTO `cart` VALUES (8, 1, 1, 'material', '2018-05-01', '2018-05-02', 5, 1);
INSERT INTO `cart` VALUES (9, 1, 1, 'hotel', '2018-05-01', '2018-05-02', 66, 1);
INSERT INTO `cart` VALUES (10, 1, 1, 'hotel', '2018-05-02', '2018-05-04', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for catering
-- ----------------------------
DROP TABLE IF EXISTS `catering`;
CREATE TABLE `catering` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL DEFAULT 1,
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '餐饮服务名',
  `pic` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片',
  `desc` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of catering
-- ----------------------------
BEGIN;
INSERT INTO `catering` VALUES (1, 1, 'catering1', '/images/catering/catering1.jpg', 'this is very good');
COMMIT;

-- ----------------------------
-- Table structure for hotel
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL DEFAULT 1,
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '酒店名称',
  `code` varchar(40) NOT NULL DEFAULT '' COMMENT '编码',
  `pic` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片',
  `desc` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
  `num` int(11) NOT NULL DEFAULT 0 COMMENT '房间数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hotel
-- ----------------------------
BEGIN;
INSERT INTO `hotel` VALUES (1, 1, 'hotel1', '001', '/images/hotel/hotel1.jpg', 'this is hotel1', 0);
INSERT INTO `hotel` VALUES (2, 1, 'hotel2', '002', '/images/hotel/hotel2.jpg', 'this is hotel1', 4);
INSERT INTO `hotel` VALUES (3, 1, 'hotel3', '003', '/images/hotel/hotel3.jpg', 'this is hotel1', 99);
INSERT INTO `hotel` VALUES (4, 1, 'hotel4', '004', '/images/hotel/hotel4.jpg', 'this is hotel1', 44);
INSERT INTO `hotel` VALUES (5, 1, 'hotel5', '005', '/images/hotel/hotel5.jpg', 'this is hotel1', 45);
INSERT INTO `hotel` VALUES (6, 1, 'hotel6', '006', '/images/hotel/hotel6.jpg', 'this is hotel1', 66);
COMMIT;

-- ----------------------------
-- Table structure for material
-- ----------------------------
DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) NOT NULL DEFAULT 1,
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '器材名称',
  `pic` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片',
  `desc` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
  `num` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of material
-- ----------------------------
BEGIN;
INSERT INTO `material` VALUES (1, 1, 'material1', '/images/material/material1.jpg', 'description description', 29);
INSERT INTO `material` VALUES (2, 3, 'material3', '/images/material/material3.jpg', 'fsdfd description description', 10);
COMMIT;

-- ----------------------------
-- Table structure for skiing_park
-- ----------------------------
use project;
DROP TABLE IF EXISTS `skiing_park`;
CREATE TABLE `skiing_park` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '滑雪场名称',
  `pic` varchar(1000) NOT NULL DEFAULT '' COMMENT '图片',
  `desc` varchar(100) NOT NULL DEFAULT '' COMMENT '描述',
  `area` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of skiing_park
-- ----------------------------
BEGIN;
INSERT INTO `skiing_park` VALUES (1, 'skiing park one1', '/images/skiingpark/skiingpark1.jpg,/images/skiingpark/skiingpark2.jpg,/images/skiingpark/skiingpark3.jpg,/images/skiingpark/skiingpark4.jpg', 'skiing park one is very good', 'beijing');
INSERT INTO `skiing_park` VALUES (2, 'skiing park two', '/images/skiingpark/skiingpark10.jpg', 'skiing park two is very nice.', 'nanjing');
INSERT INTO `skiing_park` VALUES (3, 'skiing park three', '/images/skiingpark/skiingpark11.jpg', 'this is very good.', 'shanghai');
INSERT INTO `skiing_park` VALUES (4, 'skiing park four', '/images/skiingpark/skiingpark12.jpg', 'this is very good.', 'wuhan');
INSERT INTO `skiing_park` VALUES (5, 'skiing park five', '/images/skiingpark/skiingpark5.jpg,/images/skiingpark/skiingpark6.jpg,/images/skiingpark/skiingpark7.jpg', 'description description', 'beijing');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(15) NOT NULL DEFAULT '',
  `last_name` varchar(15) NOT NULL DEFAULT '',
  `email` varchar(40) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `gender` tinyint(1) NOT NULL DEFAULT 1,
  `birthday` date NOT NULL DEFAULT '0000-00-00',
  `country` varchar(40) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', 'admin', 'admin@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 1, '2018-05-01', '中国', 1, 1);
INSERT INTO `user` VALUES (2, 'test', 'test0', 'test@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 0, '2018-05-09', 'china', 1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
